A Design of Intelligent Pre-fetching Materialized Views Mechanism for Enhancing Summary Queries on Data Warehouses

To build up a materialized view that perfectly satisfies the need of the specific enterprise it serves is now the biggest challenge especially when it comes to larger and larger scale enterprises as well as more and more complicated and yet necessary socio-economical information. In this paper, we shall develop an Intelligent Materialized VIews Pre-fetching mechanism, also known as an IMVIP, from the characteristics of affinity grouping so as to enhance the efficiency of summary data warehouse querying. The IMVIP mechanism consists of the following two methods: the Apriori-Model association method and the Linear Structure Relation. The Apriori-Model association method explores and deduces the combination of the relations among individual user session. It is especially suitable for applications where the combinations of the relations are to be explored among multi-objective queries made by more than one decision maker. On the other hand, the Linear Structure Relation Model develops a set of principles as to the explorations into the deduced relation combination above with an aim to constructing a series of causal-effect association rules. Thus, we can not only pre-fetch and materialize views that really satisfy the needs of the decision makers so as to enhance the efficiency of summary data warehouse queries but also build up intelligent query paths according to the cause-and-effect association rules in order to attain the goal of providing helpful suggestions for decision-making

The Relationships among Chinese Practicing Teachers ’ Epistemic Beliefs, Pedagogical Beliefs and Their Beliefs about the Use of ICT

This study aimed to investigate the relationships among practicing teachers ’ epistemic beliefs, pedagogical beliefs and their beliefs about the use of ICT through survey methodology. Participants were 396 high school practicing teachers from mainland China. The path analysis results analyzed via structural equation modelling technique indicated that the systemic relationships among these three types of beliefs were nested. Specifically, teachers ’ sophisticated beliefs about the source of knowledge were aligned with constructivist pedagogical beliefs and constructivist use of ICT, with one belief highly related to another

Knockdown of PsbO leads to induction of HydA and production of photobiological H2 in the green alga Chlorella sp. DT

Green algae are able to convert solar energy to H2 via the photosynthetic electron transport pathway under certain conditions. Algal hydrogenase (HydA, encoded by HYDA) is in charge of catalyzing the reaction: 2H+ + 2e− ↔ H2 but usually inhibited by O2, a byproduct of photosynthesis. The aim of this study was to knockdown PsbO (encoded by psbO), a subunit concerned with O2 evolution, so that it would lead to HydA induction. The alga, Chlorella sp. DT, was then transformed with short interference RNA antisense-psbO (siRNA-psbO) fragments. The algal mutants were selected by checking for the existence of siRNA-psbO fragments in their genomes and the low amount of PsbO proteins. The HYDA transcription and the HydA expression were observed in the PsbO-knockdown mutants. Under semi-aerobic condition, PsbO-knockdown mutants could photobiologically produce H2 which increased by as much as 10-fold in comparison to the wild type

Deep Learning for Spin-Orbit Torque Characterizations with a Projected Vector Field Magnet

Spin-orbit torque characterizations on magnetic heterostructures with perpendicular anisotropy are demonstrated on a projected vector field magnet via hysteresis loop shift measurement and harmonic Hall measurement with planar Hall correction. Accurate magnetic field calibration of the vector magnet is realized with the help of deep learning models, which are able to capture the nonlinear behavior between the generated magnetic field and the currents applied to the magnet. The trained models can successfully predict the applied current combinations under the circumstances of magnetic field scans, angle scans, and hysteresis loop shift measurements. The validity of the models is further verified, complemented by the comparison of the spin-orbit torque characterization results obtained from the deep-learning-trained vector magnet system with those obtained from a conventional setup comprised of two separated electromagnets. The damping-like spin-orbit torque (DL-SOT) efficiencies (|$\xi_{DL}$|) extracted from the vector magnet and the traditional measurement configuration are consistent, where |$\xi_{DL}$| $\approx$ 0.22 for amorphous W and |$\xi_{DL}$| $\approx$ 0.02 for $\alpha$-W. Our work provides an advanced method to meticulously control a vector magnet and to conveniently perform various spin-orbit torque characterizations

Open lung biopsy in early-stage acute respiratory distress syndrome

INTRODUCTION: Acute respiratory distress syndrome (ARDS) has heterogeneous etiologies, rapid progressive change and a high mortality rate. To improve the outcome of ARDS, accurate diagnosis is essential to the application of effective early treatment. The present study investigated the clinical effects and safety of open lung biopsy (OLB) in patients with early-stage ARDS of suspected non-infectious origin. METHODS: We undertook a retrospective study of 41 patients with early-stage ARDS (defined as one week or less after intubation) who underwent OLB in two medical intensive care units of a tertiary care hospital from 1999 to 2005. Data analyzed included baseline characteristics, complication rate, pathological diagnoses, treatment alterations, and hospital survival. RESULTS: The age of patients was 55 ± 17 years (mean ± SD). The average ratio of arterial partial pressure of oxygen (PaO(2)) to fraction of inspired oxygen (FiO(2)) was 116 ± 43 mmHg (mean ± SD) at biopsy. Seventeen patients (41%) were immunocompromised. Postoperative complications occurred in 20% of patients (8/41). All biopsies provided a pathological diagnosis with a diagnostic yield of 100%. Specific pathological diagnoses were made for 44% of patients (18/41). Biopsy findings led to an alteration of treatment modality in 73% of patients (30/41). The treatment alteration rate was higher in patients with nonspecific diagnoses than in patients with specific diagnoses (p = 0.0024). Overall mortality was 50% (21/41) and was not influenced by age, gender, pre-OLB oxygenation, complication rate, pathological results, and alteration of treatment. There was no surgery-related mortality. The survival rate for immunocompromised patients was better than that for immunocompetent patients (71% versus 33%; p = 0.0187) in this study. CONCLUSION: Our retrospective study suggests that OLB was a useful and acceptably safe diagnostic procedure in some selected patients with early-stage ARDS

Biomechanical investigation of flexor digitorum tendons in trigger finger patients using sonography

Trigger finger (TF) has generally been ascribed to primary changes in the first annular (A1) pulley. Repeated friction between the A1 pulley and flexor digitorum tendons could result in swelling of soft tissues, and thus it has been speculated that TF affects tendons’ biomechanical behaviors. However, the pathology mechanism related to these behaviors remains unclear. The purposes of this study are to understand (1) the variations in the morphologies of the flexor digitorum profundus (FDP) and flexor digitorum superficialis (FDS) between normal fingers and TFs, (2) the differences in the biomechanical behaviors of the FDP and FDS between normal fingers and TFs in various finger flexion positions, and (3) the effect of various finger positions on the biomechanical behaviors of the FDP and FDS

Screen-Printed Carbon Electrodes Modified with Cobalt Phthalocyanine for Selective Sulfur Detection in Cosmetic Products

Cobalt phthalocyanine (CoPc) films were deposited on the surface of a screen-printed carbon electrode using a simple drop coating method. The cyclic voltammogram of the resulting CoPc modified screen-printed electrode (CoPc/SPE) prepared under optimum conditions shows a well-behaved redox couple due to the (CoI/CoII) system. The CoPc/SPE surface demonstrates excellent electrochemical activity towards the oxidation of sulfur in a 0.01 mol·L−1 NaOH. A linear calibration curve with the detection limit (DL, S/N = 3) of 0.325 mg·L−1 was achieved by CoPc/SPE coupled with flow injection analysis of the sulfur concentration ranging from 4 to 1120 mg·L−1. The precision of the system response was evaluated (3.60% and 3.52% RSD for 12 repeated injections), in the range of 64 and 480 mg·L−1 sulfur. The applicability of the method was successfully demonstrated in a real sample analysis of sulfur in anti-acne creams, and good recovery was obtained. The CoPc/SPE displayed several advantages in sulfur determination including easy fabrication, high stability, and low cost